/**
 *  iBizSys 5.0 机器人生产代码（不要直接修改当前代码）
 *  http://www.ibizsys.net
 */
package net.ibizsys.psrt.srv.common.demodel.codeitem.dataquery;



import net.ibizsys.paas.core.DEDataQuery;
import net.ibizsys.paas.core.DEDataQueryCodes;
import net.ibizsys.paas.core.DEDataQueryCode;
import net.ibizsys.paas.core.DEDataQueryCodeExp;
import net.ibizsys.paas.core.DEDataQueryCodeCond;

@DEDataQuery(id="05FAA261-0651-458F-8269-ECD08771AFD9",name="DEFAULT")
@DEDataQueryCodes({
    @DEDataQueryCode(querycode="SELECT t1.CODEITEMID AS CODEITEMID, t1.CODEITEMNAME AS CODEITEMNAME, t1.CODEITEMVALUE AS CODEITEMVALUE, t1.CODELISTID AS CODELISTID, t11.CODELISTNAME AS CODELISTNAME, t1.CREATEDATE AS CREATEDATE, t1.CREATEMAN AS CREATEMAN, t1.MEMO AS MEMO, t1.ORDERVALUE AS ORDERVALUE, t1.PCODEITEMID AS PCODEITEMID, t21.CODEITEMNAME AS PCODEITEMNAME, t1.SHORTKEY AS SHORTKEY, t1.UPDATEDATE AS UPDATEDATE, t1.UPDATEMAN AS UPDATEMAN FROM T_SRFCODEITEM t1  LEFT JOIN T_SRFCODELIST t11 ON t1.CODELISTID = t11.CODELISTID  LEFT JOIN T_SRFCODEITEM t21 ON t1.PCODEITEMID = t21.CODEITEMID ",querycodetemp="",declarecode="",dbtype="DB2",
    fieldexps={
        @DEDataQueryCodeExp(name="CODEITEMID",expression="t1.CODEITEMID")
        ,@DEDataQueryCodeExp(name="CODEITEMNAME",expression="t1.CODEITEMNAME")
        ,@DEDataQueryCodeExp(name="CODEITEMVALUE",expression="t1.CODEITEMVALUE")
        ,@DEDataQueryCodeExp(name="CODELISTID",expression="t1.CODELISTID")
        ,@DEDataQueryCodeExp(name="CODELISTNAME",expression="t11.CODELISTNAME")
        ,@DEDataQueryCodeExp(name="CREATEDATE",expression="t1.CREATEDATE")
        ,@DEDataQueryCodeExp(name="CREATEMAN",expression="t1.CREATEMAN")
        ,@DEDataQueryCodeExp(name="MEMO",expression="t1.MEMO")
        ,@DEDataQueryCodeExp(name="ORDERVALUE",expression="t1.ORDERVALUE")
        ,@DEDataQueryCodeExp(name="PCODEITEMID",expression="t1.PCODEITEMID")
        ,@DEDataQueryCodeExp(name="PCODEITEMNAME",expression="t21.CODEITEMNAME")
        ,@DEDataQueryCodeExp(name="SHORTKEY",expression="t1.SHORTKEY")
        ,@DEDataQueryCodeExp(name="UPDATEDATE",expression="t1.UPDATEDATE")
        ,@DEDataQueryCodeExp(name="UPDATEMAN",expression="t1.UPDATEMAN")
    },
    conds={}),
    @DEDataQueryCode(querycode="SELECT t1.CODEITEMID AS CODEITEMID, t1.CODEITEMNAME AS CODEITEMNAME, t1.CODEITEMVALUE AS CODEITEMVALUE, t1.CODELISTID AS CODELISTID, t11.CODELISTNAME AS CODELISTNAME, t1.CREATEDATE AS CREATEDATE, t1.CREATEMAN AS CREATEMAN, t1.MEMO AS MEMO, t1.ORDERVALUE AS ORDERVALUE, t1.PCODEITEMID AS PCODEITEMID, t21.CODEITEMNAME AS PCODEITEMNAME, t1.SHORTKEY AS SHORTKEY, t1.UPDATEDATE AS UPDATEDATE, t1.UPDATEMAN AS UPDATEMAN FROM T_SRFCODEITEM t1  LEFT JOIN T_SRFCODELIST t11 ON t1.CODELISTID = t11.CODELISTID  LEFT JOIN T_SRFCODEITEM t21 ON t1.PCODEITEMID = t21.CODEITEMID ",querycodetemp="",declarecode="",dbtype="MYSQL5",
    fieldexps={
        @DEDataQueryCodeExp(name="CODEITEMID",expression="t1.CODEITEMID")
        ,@DEDataQueryCodeExp(name="CODEITEMNAME",expression="t1.CODEITEMNAME")
        ,@DEDataQueryCodeExp(name="CODEITEMVALUE",expression="t1.CODEITEMVALUE")
        ,@DEDataQueryCodeExp(name="CODELISTID",expression="t1.CODELISTID")
        ,@DEDataQueryCodeExp(name="CODELISTNAME",expression="t11.CODELISTNAME")
        ,@DEDataQueryCodeExp(name="CREATEDATE",expression="t1.CREATEDATE")
        ,@DEDataQueryCodeExp(name="CREATEMAN",expression="t1.CREATEMAN")
        ,@DEDataQueryCodeExp(name="MEMO",expression="t1.MEMO")
        ,@DEDataQueryCodeExp(name="ORDERVALUE",expression="t1.ORDERVALUE")
        ,@DEDataQueryCodeExp(name="PCODEITEMID",expression="t1.PCODEITEMID")
        ,@DEDataQueryCodeExp(name="PCODEITEMNAME",expression="t21.CODEITEMNAME")
        ,@DEDataQueryCodeExp(name="SHORTKEY",expression="t1.SHORTKEY")
        ,@DEDataQueryCodeExp(name="UPDATEDATE",expression="t1.UPDATEDATE")
        ,@DEDataQueryCodeExp(name="UPDATEMAN",expression="t1.UPDATEMAN")
    },
    conds={}),
    @DEDataQueryCode(querycode="SELECT t1.CODEITEMID AS CODEITEMID, t1.CODEITEMNAME AS CODEITEMNAME, t1.CODEITEMVALUE AS CODEITEMVALUE, t1.CODELISTID AS CODELISTID, t11.CODELISTNAME AS CODELISTNAME, t1.CREATEDATE AS CREATEDATE, t1.CREATEMAN AS CREATEMAN, t1.MEMO AS MEMO, t1.ORDERVALUE AS ORDERVALUE, t1.PCODEITEMID AS PCODEITEMID, t21.CODEITEMNAME AS PCODEITEMNAME, t1.SHORTKEY AS SHORTKEY, t1.UPDATEDATE AS UPDATEDATE, t1.UPDATEMAN AS UPDATEMAN FROM T_SRFCODEITEM t1  LEFT JOIN T_SRFCODELIST t11 ON t1.CODELISTID = t11.CODELISTID  LEFT JOIN T_SRFCODEITEM t21 ON t1.PCODEITEMID = t21.CODEITEMID ",querycodetemp="",declarecode="",dbtype="ORACLE",
    fieldexps={
        @DEDataQueryCodeExp(name="CODEITEMID",expression="t1.CODEITEMID")
        ,@DEDataQueryCodeExp(name="CODEITEMNAME",expression="t1.CODEITEMNAME")
        ,@DEDataQueryCodeExp(name="CODEITEMVALUE",expression="t1.CODEITEMVALUE")
        ,@DEDataQueryCodeExp(name="CODELISTID",expression="t1.CODELISTID")
        ,@DEDataQueryCodeExp(name="CODELISTNAME",expression="t11.CODELISTNAME")
        ,@DEDataQueryCodeExp(name="CREATEDATE",expression="t1.CREATEDATE")
        ,@DEDataQueryCodeExp(name="CREATEMAN",expression="t1.CREATEMAN")
        ,@DEDataQueryCodeExp(name="MEMO",expression="t1.MEMO")
        ,@DEDataQueryCodeExp(name="ORDERVALUE",expression="t1.ORDERVALUE")
        ,@DEDataQueryCodeExp(name="PCODEITEMID",expression="t1.PCODEITEMID")
        ,@DEDataQueryCodeExp(name="PCODEITEMNAME",expression="t21.CODEITEMNAME")
        ,@DEDataQueryCodeExp(name="SHORTKEY",expression="t1.SHORTKEY")
        ,@DEDataQueryCodeExp(name="UPDATEDATE",expression="t1.UPDATEDATE")
        ,@DEDataQueryCodeExp(name="UPDATEMAN",expression="t1.UPDATEMAN")
    },
    conds={}),
    @DEDataQueryCode(querycode="SELECT t1.CODEITEMID AS CODEITEMID, t1.CODEITEMNAME AS CODEITEMNAME, t1.CODEITEMVALUE AS CODEITEMVALUE, t1.CODELISTID AS CODELISTID, t11.CODELISTNAME AS CODELISTNAME, t1.CREATEDATE AS CREATEDATE, t1.CREATEMAN AS CREATEMAN, t1.MEMO AS MEMO, t1.ORDERVALUE AS ORDERVALUE, t1.PCODEITEMID AS PCODEITEMID, t21.CODEITEMNAME AS PCODEITEMNAME, t1.SHORTKEY AS SHORTKEY, t1.UPDATEDATE AS UPDATEDATE, t1.UPDATEMAN AS UPDATEMAN FROM T_SRFCODEITEM t1  LEFT JOIN T_SRFCODELIST t11 ON t1.CODELISTID = t11.CODELISTID  LEFT JOIN T_SRFCODEITEM t21 ON t1.PCODEITEMID = t21.CODEITEMID ",querycodetemp="",declarecode="",dbtype="SQLSERVER",
    fieldexps={
        @DEDataQueryCodeExp(name="CODEITEMID",expression="t1.CODEITEMID")
        ,@DEDataQueryCodeExp(name="CODEITEMNAME",expression="t1.CODEITEMNAME")
        ,@DEDataQueryCodeExp(name="CODEITEMVALUE",expression="t1.CODEITEMVALUE")
        ,@DEDataQueryCodeExp(name="CODELISTID",expression="t1.CODELISTID")
        ,@DEDataQueryCodeExp(name="CODELISTNAME",expression="t11.CODELISTNAME")
        ,@DEDataQueryCodeExp(name="CREATEDATE",expression="t1.CREATEDATE")
        ,@DEDataQueryCodeExp(name="CREATEMAN",expression="t1.CREATEMAN")
        ,@DEDataQueryCodeExp(name="MEMO",expression="t1.MEMO")
        ,@DEDataQueryCodeExp(name="ORDERVALUE",expression="t1.ORDERVALUE")
        ,@DEDataQueryCodeExp(name="PCODEITEMID",expression="t1.PCODEITEMID")
        ,@DEDataQueryCodeExp(name="PCODEITEMNAME",expression="t21.CODEITEMNAME")
        ,@DEDataQueryCodeExp(name="SHORTKEY",expression="t1.SHORTKEY")
        ,@DEDataQueryCodeExp(name="UPDATEDATE",expression="t1.UPDATEDATE")
        ,@DEDataQueryCodeExp(name="UPDATEMAN",expression="t1.UPDATEMAN")
    },
    conds={})
})
/**
 *  实体数据查询 [DEFAULT]模型基类
 */
public abstract class CodeItemDefaultDQModelBase extends net.ibizsys.paas.demodel.DEDataQueryModelBase {

    public CodeItemDefaultDQModelBase() {
        super();

        this.initAnnotation(CodeItemDefaultDQModelBase.class);
    }

}